4D ODBC Pro v12

ODBC_SQLPrepare

Home

 
4D ODBC Pro v12
ODBC_SQLPrepare

 

ODBC_SQLPrepare 


 

ODBC_SQLPrepare ( stmtID ; statementText ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
statementText  Text in SQL text string
Function result  Longint in Returns the result of the MS ODBC API function SQLPrepare

The ODBC_SQLPrepare command prepares a SQL string for execution passed in statementText.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

statementText is the SQL text string to be executed later with ODBC_SQLExecute.

For more information, please see the SQLPrepare function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms710926(VS.85).aspx.

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

Example  

See the example for the ODBC_SQLFetch command.

 
PROPERTIES 

Product: 4D ODBC Pro
Theme: ODBC_Prepare requests
Number: 16975

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLExecute
ODBC_SQLFetch